SherbyNet - /page/wikibook/entry.mu

Micron Document

<!DOCTYPE html>

<title>SQL Server Compact</title>

</head>

<span id="openzim-page-title" class="mw-page-title-main"><span class="mw-page-title-main">SQL Server Compact</span></span>

</h1>

</header>

<p><b>Microsoft SQL Server Compact</b> (<b>SQL CE</b>) is a discontinued <a href="Relational_database" title="Relational database">relational database</a> produced by <a href="Microsoft" title="Microsoft">Microsoft</a> for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as <i>SQL Server for <a href="Windows_Embedded_Compact" class="mw-redirect" title="Windows Embedded Compact">Windows CE</a></i> and <i>SQL Server Mobile Edition</i>.

</p><p>It includes both 32-bit and 64-bit native support.<sup id="cite_ref-40Release_1-0" class="reference"><a href="#cite_note-40Release-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup> SQL CE targets occasionally connected applications and applications with an embedded database.<sup id="cite_ref-Datasheet_2-0" class="reference"><a href="#cite_note-Datasheet-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> It is free to download and redistribute.<sup id="cite_ref-Datasheet_2-1" class="reference"><a href="#cite_note-Datasheet-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> An <a href="Open_Database_Connectivity" title="Open Database Connectivity">ODBC</a> driver for SQL CE does not exist, nor is one planned. Native applications may use SQL CE via <a href="OLE_DB" title="OLE DB">OLE DB</a>.

</p><p>The latest, and last, release is SQL Server Compact 4.0.<sup id="cite_ref-40Release_1-1" class="reference"><a href="#cite_note-40Release-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup> In February 2013 SQL Server Compact Edition had been deprecated; no new versions or updates are planned, although Microsoft continued to support the product until July 2021.<sup id="cite_ref-LCSQLCE40_3-0" class="reference"><a href="#cite_note-LCSQLCE40-3"><span class="cite-bracket">[</span>3<span class="cite-bracket">]</span></a></sup>

</p>

<div class="mw-heading mw-heading2"><h2 id="Overview">Overview</h2></div>

<p>SQL Server Compact shares a common <a href="Application_Programming_Interface" class="mw-redirect" title="Application Programming Interface">API</a> with the other <a href="Microsoft_SQL_Server" title="Microsoft SQL Server">Microsoft SQL Server</a> editions.<sup id="cite_ref-Lap1_4-0" class="reference"><a href="#cite_note-Lap1-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup> It also includes <a href="ADO.NET" title="ADO.NET">ADO.NET</a> providers for data access using ADO.NET APIs, and built-in synchronization capabilities,<sup id="cite_ref-Datasheet_2-2" class="reference"><a href="#cite_note-Datasheet-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> as well as support for <a href="Language_Integrated_Query" title="Language Integrated Query">LINQ</a> and <a href="Entity_Framework" title="Entity Framework">Entity Framework</a>. Future releases will unify the synchronization capabilities with <a href="Microsoft_Synchronization_Services" class="mw-redirect" title="Microsoft Synchronization Services">Microsoft Synchronization Services</a>.<sup id="cite_ref-JAD_5-0" class="reference"><a href="#cite_note-JAD-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> Unlike other editions of <a href="Microsoft_SQL_Server" title="Microsoft SQL Server">Microsoft SQL Server</a>, SQL CE runs in-process<sup id="cite_ref-JAD_5-1" class="reference"><a href="#cite_note-JAD-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> with the application which is hosting it. It has a disk footprint of less than 2 <a href="Megabyte" title="Megabyte">MB</a> and a <a href="Memory_footprint" title="Memory footprint">memory footprint</a> of approximately 5 MB.<sup id="cite_ref-Datasheet_2-3" class="reference"><a href="#cite_note-Datasheet-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> SQL CE is optimized for an architecture where all applications share the same memory pool.<sup id="cite_ref-New_6-0" class="reference"><a href="#cite_note-New-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup>

<a href="Windows_Store_app" class="mw-redirect" title="Windows Store app">Windows Store apps</a> for Windows 8 cannot use SQL Server Compact edition, or any other edition of SQL Server.<sup id="cite_ref-NoSSCEonRT_7-0" class="reference"><a href="#cite_note-NoSSCEonRT-7"><span class="cite-bracket">[</span>7<span class="cite-bracket">]</span></a></sup>

</p>

<caption>Versions

</caption>

<th>Official name

</th>

<th>Common name

</th>

<th>Release date

</th>

<th>Support date

</th></tr>

<tr>

/* start https://en.wikipedia.org/ */

.mw-parser-output .plainlist ol,.mw-parser-output .plainlist ul{line-height:inherit;list-style:none;margin:0;padding:0}.mw-parser-output .plainlist ol li,.mw-parser-output .plainlist ul li{margin-bottom:0}

/* end https://en.wikipedia.org/ */

</style><div class="plainlist"><ul><li>SQL Server 2000 Windows CE Edition</li><li>SQL Server CE 1.0</li></ul></div>

</td>

<td>SQL CE 1.0

</td>

</td>

<td>

</td></tr>

<tr>

<td><div class="plainlist"><ul><li>SQL Server 2000 Windows CE Edition 1.1</li><li>SQL Server CE 1.1</li></ul></div>

</td>

<td>SQL CE 1.1

</td>

</td>

<td>

</td></tr>

<tr>

<td><div class="plainlist"><ul><li>SQL Server 2000 Windows CE Edition 2.0</li><li>SQL Server CE 2.0</li></ul></div>

</td>

<td>SQL CE 2.0

</td>

</td>

<td>

</td></tr>

<tr>

<td>SQL Server 2005 Mobile Edition

</td>

<td>SQL CE 3.0

</td>

<td>2006-01-14

</td>

<td>

</td></tr>

<tr>

<td>SQL Server 2005 Compact Edition

</td>

<td>SQL CE 3.1

</td>

<td>2007-02-19

</td>

</td></tr>

<tr>

<td>SQL Server Compact 3.5

</td>

<td>SQL CE 3.5

</td>

<td>2008-02-19

</td>

</td></tr>

<tr>

<td>SQL Server Compact 4.0

</td>

<td>SQL CE 4.0

</td>

<td>2011-04-13

</td>

</td></tr></tbody></table>

<div class="mw-heading mw-heading2"><h2 id="Support">Support</h2></div>

<p>SQL CE databases can support <a href="ACID" title="ACID">ACID</a>-compliance, but do not meet the durability requirement by default because AutoFlush buffers changes in memory (including enlisted ambient transactions and explicit SQL CE transactions that do not override the Commit() call with an CommitMode.Immediate value). Therefore, committed transaction changes can be lost. To meet the durability requirement the commit call on the transaction must specify the immediate flag.<sup id="cite_ref-MSDNAutoFlush_13-0" class="reference"><a href="#cite_note-MSDNAutoFlush-13"><span class="cite-bracket">[</span>13<span class="cite-bracket">]</span></a></sup> Like <a href="Microsoft_SQL_Server" title="Microsoft SQL Server">Microsoft SQL Server</a>, SQL CE supports transactions, referential integrity constraints, locking as well as multiple connections to the database store.<sup id="cite_ref-Lap1_4-1" class="reference"><a href="#cite_note-Lap1-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup> However, <a href="Nested_transaction" title="Nested transaction">nested transactions</a> are not supported, even though parallel transactions (on different tables) are.<sup id="cite_ref-14" class="reference"><a href="#cite_note-14"><span class="cite-bracket">[</span>14<span class="cite-bracket">]</span></a></sup> The current release does not support <a href="Stored_procedures" class="mw-redirect" title="Stored procedures">stored procedures</a><sup id="cite_ref-Lap1_4-2" class="reference"><a href="#cite_note-Lap1-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup> or native <a href="XML" title="XML">XML</a> data type either.<sup id="cite_ref-JAD_5-2" class="reference"><a href="#cite_note-JAD-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> It uses a subset of <a href="T-SQL" class="mw-redirect" title="T-SQL">T-SQL</a><sup id="cite_ref-Datasheet_2-4" class="reference"><a href="#cite_note-Datasheet-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> for querying and due to lack of XML support, <a href="XQuery" title="XQuery">XQuery</a> is not supported either.<sup id="cite_ref-JAD_5-3" class="reference"><a href="#cite_note-JAD-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup> Queries are processed by an optimizing query processor.<sup id="cite_ref-Feat_15-0" class="reference"><a href="#cite_note-Feat-15"><span class="cite-bracket">[</span>15<span class="cite-bracket">]</span></a></sup> SQL CE databases also support indexing, as well as support remote data replication (local caching of data in remote databases) and merge replication (bidirectional synchronization with master databases).<sup id="cite_ref-16" class="reference"><a href="#cite_note-16"><span class="cite-bracket">[</span>16<span class="cite-bracket">]</span></a></sup>

</p><p>SQL CE databases can be created and managed from <a href="Microsoft_Visual_Studio" class="mw-redirect" title="Microsoft Visual Studio">Microsoft Visual Studio</a> and some older versions of <a href="SQL_Server_Management_Studio" title="SQL Server Management Studio">SQL Server Management Studio</a> as well.<sup id="cite_ref-Feat_15-1" class="reference"><a href="#cite_note-Feat-15"><span class="cite-bracket">[</span>15<span class="cite-bracket">]</span></a></sup>

</p>

<div class="mw-heading mw-heading2"><h2 id="File_format">File format</h2></div>

/* start https://en.wikipedia.org/ */

.mw-parser-output .infobox-subbox{padding:0;border:none;margin:-3px;width:auto;min-width:100%;font-size:100%;clear:none;float:none;background-color:transparent}.mw-parser-output .infobox-3cols-child{margin:auto}.mw-parser-output .infobox .navbar{font-size:100%}@media screen{html.skin-theme-clientpref-night .mw-parser-output .infobox-full-data:not(.notheme)>div:not(.notheme)[style]{background:#1f1f23!important;color:#f8f9fa}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .infobox-full-data:not(.notheme)>div:not(.notheme)[style]{background:#1f1f23!important;color:#f8f9fa}}@media(min-width:640px){body.skin--responsive .mw-parser-output .infobox-table{display:table!important}body.skin--responsive .mw-parser-output .infobox-table>caption{display:table-caption!important}body.skin--responsive .mw-parser-output .infobox-table>tbody{display:table-row-group}body.skin--responsive .mw-parser-output .infobox-table th,body.skin--responsive .mw-parser-output .infobox-table td{padding-left:inherit;padding-right:inherit}}

/* end https://en.wikipedia.org/ */

</style><table class="infobox"><tbody><tr><th colspan="2" class="infobox-above" style="padding-bottom: 0.15em;">SQL Server Compact</th></tr><tr><th scope="row" class="infobox-label" style="line-height: 1.2; padding-right: 0.65em;"><a href="Filename_extension" title="Filename extension">Filename extension</a></th><td class="infobox-data" style="line-height: 1.35;"><style data-mw-deduplicate="TemplateStyles:r886049734">

/* start https://en.wikipedia.org/ */

.mw-parser-output .monospaced{font-family:monospace,monospace}

/* end https://en.wikipedia.org/ */

</style><div class="monospaced">

<code>.sdf</code></div></td></tr><tr><th scope="row" class="infobox-label" style="line-height: 1.2; padding-right: 0.65em;">Developed by</th><td class="infobox-data" style="line-height: 1.35;"><a href="Microsoft" title="Microsoft">Microsoft</a></td></tr><tr><th scope="row" class="infobox-label" style="line-height: 1.2; padding-right: 0.65em;">Type of format</th><td class="infobox-data" style="line-height: 1.35;"><a href="Relational_database" title="Relational database">Relational database</a></td></tr></tbody></table>

<p>SQL CE databases reside in a single <i><b>.sdf</b></i> file,<sup id="cite_ref-Arch_17-0" class="reference"><a href="#cite_note-Arch-17"><span class="cite-bracket">[</span>17<span class="cite-bracket">]</span></a></sup> which can be up to 4 <a href="Gigabyte" title="Gigabyte">GB</a> in size.<sup id="cite_ref-Lap1_4-3" class="reference"><a href="#cite_note-Lap1-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup> The <i>.sdf</i> file can be encrypted with 128-bit <a href="Encryption" title="Encryption">encryption</a> for data security.<sup id="cite_ref-Arch_17-1" class="reference"><a href="#cite_note-Arch-17"><span class="cite-bracket">[</span>17<span class="cite-bracket">]</span></a></sup> SQL CE runtime mediates concurrent multi-user access to the <i>.sdf</i> file. The <i>.sdf</i> file can simply be copied to the destination system for deployment, or be deployed through <a href="ClickOnce" title="ClickOnce">ClickOnce</a>. SQL CE runtime has support for DataDirectories.<sup id="cite_ref-New_6-1" class="reference"><a href="#cite_note-New-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup> Applications using an SQL CE database need not specify the entire path to an <i>.sdf</i> file in the <a href="ADO.NET" title="ADO.NET">ADO.NET</a> connection string, rather it can be specified as <i>|DataDirectory|\<database_name>.sdf</i>, defining the data directory (where the <i>.sdf</i> database file resides) being defined in the <a href="Manifest_(CLI)" title="Manifest (CLI)">assembly manifest</a> for the application.

</p><p>SQL Server Management Studio 2005 can read and modify CE 3.0 and 3.1 database files (with the latest service pack), but SQL Server Management Studio 2008 (or later) is required to read version 3.5 files. Microsoft Visual Studio Express 2008 SP1 can create, modify, and query CE 3.5 SP1 database files. SQL Server Management Studio cannot read CE 4.0 files. Visual Studio 2010 SP1 can handle CE 4.0 database files.

</p><p>The .sdf ("Sqlce Database File") naming convention is optional, and any extension can be used.

</p><p>Setting a password for the database file is optional. The database can be compressed and repaired with the option of the compacted/repaired database to be placed into a new database file.

</p>

<div class="mw-heading mw-heading2"><h2 id="Deprecation">Deprecation</h2></div>

<p>In February 2013, Microsoft announced that SQL Server Compact Edition had been deprecated.<sup id="cite_ref-18" class="reference"><a href="#cite_note-18"><span class="cite-bracket">[</span>18<span class="cite-bracket">]</span></a></sup>

</p><p>Although no new versions or updates are planned, Microsoft will continue to support SQL Compact through their standard lifecycle support policy. Extended support for SQL Server Compact 4.0 ended on July 13, 2021.<sup id="cite_ref-19" class="reference"><a href="#cite_note-19"><span class="cite-bracket">[</span>19<span class="cite-bracket">]</span></a></sup>

</p>

<ul><li><a href="Mobile_database" title="Mobile database">Mobile database</a></li>

<li><a href="SQLite" title="SQLite">SQLite</a></li>

<li><a href="SQL_Server_Express#LocalDB" title="SQL Server Express">SQL Server Express § LocalDB</a></li>

<li><a href="Access_Database_Engine" title="Access Database Engine">Access Database Engine</a> (ACE and formerly JET)</li>

<li><a href="HSQLDB" title="HSQLDB">HSQLDB</a></li>

<li><a href="Firebird_(database_server)" title="Firebird (database server)">Firebird</a></li></ul>

<div class="mw-heading mw-heading2"><h2 id="References">References</h2></div>

/* start https://en.wikipedia.org/ */

.mw-parser-output .reflist{margin-bottom:0.5em;list-style-type:decimal}@media screen{.mw-parser-output .reflist{font-size:90%}}.mw-parser-output .reflist .references{font-size:100%;margin-bottom:0;list-style-type:inherit}.mw-parser-output .reflist-columns-2{column-width:30em}.mw-parser-output .reflist-columns-3{column-width:25em}.mw-parser-output .reflist-columns{margin-top:0.3em}.mw-parser-output .reflist-columns ol{margin-top:0}.mw-parser-output .reflist-columns li{page-break-inside:avoid;break-inside:avoid-column}.mw-parser-output .reflist-upper-alpha{list-style-type:upper-alpha}.mw-parser-output .reflist-upper-roman{list-style-type:upper-roman}.mw-parser-output .reflist-lower-alpha{list-style-type:lower-alpha}.mw-parser-output .reflist-lower-greek{list-style-type:lower-greek}.mw-parser-output .reflist-lower-roman{list-style-type:lower-roman}

/* end https://en.wikipedia.org/ */

</style><div class="reflist">

/* start https://en.wikipedia.org/ */

.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("./mw/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("./mw/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("./mw/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("./mw/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}

/* end https://en.wikipedia.org/ */

</style><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://cloudblogs.microsoft.com/sqlserver/2011/01/13/microsoft-sql-server-compact-4-0-is-available-for-download-and-use-with-webmatrix/">"Microsoft SQL Server Compact 4.0 is available for download and use with WebMatrix"</a>. 13 January 2011<span class="reference-accessdate">. Retrieved <span class="nowrap">2020-03-11</span></span>.</cite></span>

</li>

<li id="cite_note-Datasheet-2"><span class="mw-cite-backlink">^ <a href="#cite_ref-Datasheet_2-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-Datasheet_2-1"><sup><i><b>b</b></i></sup></a> <a href="#cite_ref-Datasheet_2-2"><sup><i><b>c</b></i></sup></a> <a href="#cite_ref-Datasheet_2-3"><sup><i><b>d</b></i></sup></a> <a href="#cite_ref-Datasheet_2-4"><sup><i><b>e</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20070316004210/http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b404e542/sqlservercompactdatasheet_final.doc">"SQL Server 2005 Compact Edition Datasheet"</a>. Archived from <a rel="nofollow" class="external text" href="http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b404e542/sqlservercompactdatasheet_final.doc">the original</a> on 2007-03-16<span class="reference-accessdate">. Retrieved <span class="nowrap">2007-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-LCSQLCE40-3"><span class="mw-cite-backlink">^ <a href="#cite_ref-LCSQLCE40_3-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-LCSQLCE40_3-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-compact-40">"Microsoft SQL Server Compact 4.0"</a>. Lifecycle. <i><a href="Microsoft_Docs" title="Microsoft Docs">Microsoft Docs</a></i><span class="reference-accessdate">. Retrieved <span class="nowrap">2021-02-26</span></span>.</cite></span>

</li>

<li id="cite_note-Lap1-4"><span class="mw-cite-backlink">^ <a href="#cite_ref-Lap1_4-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-Lap1_4-1"><sup><i><b>b</b></i></sup></a> <a href="#cite_ref-Lap1_4-2"><sup><i><b>c</b></i></sup></a> <a href="#cite_ref-Lap1_4-3"><sup><i><b>d</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://www.devx.com/dotnet/Article/33049/0">"A Lap Around SQL Server 2005 Compact Edition"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2005-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-JAD-5"><span class="mw-cite-backlink">^ <a href="#cite_ref-JAD_5-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-JAD_5-1"><sup><i><b>b</b></i></sup></a> <a href="#cite_ref-JAD_5-2"><sup><i><b>c</b></i></sup></a> <a href="#cite_ref-JAD_5-3"><sup><i><b>d</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://www.ddj.com/dept/database/193402926">"SQL Server Everywhere: Just Another Database?"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2007-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-New-6"><span class="mw-cite-backlink">^ <a href="#cite_ref-New_6-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-New_6-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://technet.microsoft.com/en-us/library/ms172417.aspx">"What's New (SQL Server Compact Edition)"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2007-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-NoSSCEonRT-7"><span class="mw-cite-backlink"><b><a href="#cite_ref-NoSSCEonRT_7-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://social.msdn.microsoft.com/Forums/en-US/winappswithcsharp/thread/f71c518c-c288-459e-917f-52b9cf8442d7">"How do i run SQL Server Compact 3.5 on Windows 8 developer preview?"</a>. social.msdn.microsoft.com<span class="reference-accessdate">. Retrieved <span class="nowrap">11 March</span> 2013</span>.</cite></span>

</li>

<li id="cite_note-8"><span class="mw-cite-backlink"><b><a href="#cite_ref-8">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://news.microsoft.com/2000/10/26/microsoft-launches-sql-server-2000-windows-ce-edition-at-pass-2000/">"Microsoft Launches SQL Server 2000 Windows CE Edition at PASS 2000"</a>. <i>news.microsoft.com</i>. 2000-10-26<span class="reference-accessdate">. Retrieved <span class="nowrap">2022-04-16</span></span>.</cite></span>

</li>

<li id="cite_note-9"><span class="mw-cite-backlink"><b><a href="#cite_ref-9">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://news.microsoft.com/2001/03/21/microsoft-delivers-support-for-embedded-devices-with-release-of-sql-server-2000-windows-ce-edition-version-1-1/">"Microsoft Delivers Support for Embedded Devices With Release of SQL Server 2000 Windows CE Edition Version 1.1"</a>. <i>news.microsoft.com</i>. 2001-03-21<span class="reference-accessdate">. Retrieved <span class="nowrap">2022-04-16</span></span>.</cite></span>

</li>

<li id="cite_note-10"><span class="mw-cite-backlink"><b><a href="#cite_ref-10">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://news.microsoft.com/2002/09/16/microsoft-delivers-next-stage-of-net-solution-for-enterprise-mobile-development/">"Microsoft Delivers Next Stage of .NET Solution For Enterprise Mobile Development"</a>. <i>news.microsoft.com</i>. 2002-09-16<span class="reference-accessdate">. Retrieved <span class="nowrap">2022-04-16</span></span>.</cite></span>

</li>

<li id="cite_note-LCSQLCE31-11"><span class="mw-cite-backlink"><b><a href="#cite_ref-LCSQLCE31_11-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2005">"Microsoft SQL Server 2005"</a>. Lifecycle. <i><a href="Microsoft_Docs" title="Microsoft Docs">Microsoft Docs</a></i><span class="reference-accessdate">. Retrieved <span class="nowrap">2021-02-26</span></span>.</cite></span>

</li>

<li id="cite_note-LCSQLCE35-12"><span class="mw-cite-backlink"><b><a href="#cite_ref-LCSQLCE35_12-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-compact-35">"Microsoft SQL Server Compact 3.5"</a>. Lifecycle. <i><a href="Microsoft_Docs" title="Microsoft Docs">Microsoft Docs</a></i><span class="reference-accessdate">. Retrieved <span class="nowrap">2021-02-26</span></span>.</cite></span>

</li>

<li id="cite_note-MSDNAutoFlush-13"><span class="mw-cite-backlink"><b><a href="#cite_ref-MSDNAutoFlush_13-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/ms172411(v=sql.90).aspx">"Maintaining Databases (SQL Server Compact Edition)"</a>. 28 June 2007.</cite></span>

</li>

<li id="cite_note-14"><span class="mw-cite-backlink"><b><a href="#cite_ref-14">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://technet.microsoft.com/en-us/library/ms172400.aspx">"Transactions (SQL Server Compact Edition)"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2007-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-Feat-15"><span class="mw-cite-backlink">^ <a href="#cite_ref-Feat_15-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-Feat_15-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://technet.microsoft.com/en-us/library/ms172037.aspx">"Overview of Databases (SQL Server Compact Edition)"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2007-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-16"><span class="mw-cite-backlink"><b><a href="#cite_ref-16">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://technet.microsoft.com/en-us/library/ms171986.aspx">"Overview of Databases (SQL Server Compact Edition)"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2007-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-Arch-17"><span class="mw-cite-backlink">^ <a href="#cite_ref-Arch_17-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-Arch_17-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://msdn2.microsoft.com/en-us/library/bb380177.aspx">"Data Storage Architecture with SQL Server 2005 Compact Edition"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2007-07-03</span></span>.</cite></span>

</li>

<li id="cite_note-18"><span class="mw-cite-backlink"><b><a href="#cite_ref-18">^</a></b></span> <span class="reference-text"><cite id="CITEREFBarranis,_Patrick2013" class="citation web cs1">Barranis, Patrick (2013-01-11). <a rel="nofollow" class="external text" href="https://connect.microsoft.com/SQLServer/feedback/details/776328/port-sql-compact-to-windows-rt">"Port SQL Compact to Windows RT"</a>. <i>Microsoft Connect</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2016-06-25</span></span>.</cite></span>

</li>

<li id="cite_note-19"><span class="mw-cite-backlink"><b><a href="#cite_ref-19">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-compact-40">"Microsoft SQL Server Compact 4.0 Support Dates"</a><span class="reference-accessdate">. Retrieved <span class="nowrap">2020-09-17</span></span>.</cite></span>

</li>

</ol></div></div>

<div class="mw-heading mw-heading2"><h2 id="External_links">External links</h2></div>

<ul><li><a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/archive/blogs/sqlservercompact/">Microsoft's Embedded Database - SQL Server Compact - Team Blog</a> at <a href="Microsoft_Learn" title="Microsoft Learn">Microsoft Learn</a></li>

<li><a rel="nofollow" class="external text" href="https://web.archive.org/web/20160215155139/http://blogs.msdn.com/b/sqlservercompact">Microsoft's Embedded Database - SQL Server Compact - Team Blog</a> at the <a href="Wayback_Machine" title="Wayback Machine">Wayback Machine</a> (archived 2016-02-15)</li></ul>

/* start https://en.wikipedia.org/ */

.mw-parser-output .hlist dl,.mw-parser-output .hlist ol,.mw-parser-output .hlist ul{margin:0;padding:0}.mw-parser-output .hlist dd,.mw-parser-output .hlist dt,.mw-parser-output .hlist li{margin:0;display:inline}.mw-parser-output .hlist.inline,.mw-parser-output .hlist.inline dl,.mw-parser-output .hlist.inline ol,.mw-parser-output .hlist.inline ul,.mw-parser-output .hlist dl dl,.mw-parser-output .hlist dl ol,.mw-parser-output .hlist dl ul,.mw-parser-output .hlist ol dl,.mw-parser-output .hlist ol ol,.mw-parser-output .hlist ol ul,.mw-parser-output .hlist ul dl,.mw-parser-output .hlist ul ol,.mw-parser-output .hlist ul ul{display:inline}.mw-parser-output .hlist .mw-empty-li{display:none}.mw-parser-output .hlist dt::after{content:": "}.mw-parser-output .hlist dd::after,.mw-parser-output .hlist li::after{content:" · ";font-weight:bold}.mw-parser-output .hlist dd:last-child::after,.mw-parser-output .hlist dt:last-child::after,.mw-parser-output .hlist li:last-child::after{content:none}.mw-parser-output .hlist dd dd:first-child::before,.mw-parser-output .hlist dd dt:first-child::before,.mw-parser-output .hlist dd li:first-child::before,.mw-parser-output .hlist dt dd:first-child::before,.mw-parser-output .hlist dt dt:first-child::before,.mw-parser-output .hlist dt li:first-child::before,.mw-parser-output .hlist li dd:first-child::before,.mw-parser-output .hlist li dt:first-child::before,.mw-parser-output .hlist li li:first-child::before{content:" (";font-weight:normal}.mw-parser-output .hlist dd dd:last-child::after,.mw-parser-output .hlist dd dt:last-child::after,.mw-parser-output .hlist dd li:last-child::after,.mw-parser-output .hlist dt dd:last-child::after,.mw-parser-output .hlist dt dt:last-child::after,.mw-parser-output .hlist dt li:last-child::after,.mw-parser-output .hlist li dd:last-child::after,.mw-parser-output .hlist li dt:last-child::after,.mw-parser-output .hlist li li:last-child::after{content:")";font-weight:normal}.mw-parser-output .hlist ol{counter-reset:listitem}.mw-parser-output .hlist ol>li{counter-increment:listitem}.mw-parser-output .hlist ol>li::before{content:" "counter(listitem)"\a0 "}.mw-parser-output .hlist dd ol>li:first-child::before,.mw-parser-output .hlist dt ol>li:first-child::before,.mw-parser-output .hlist li ol>li:first-child::before{content:" ("counter(listitem)"\a0 "}

/* end https://en.wikipedia.org/ */

</style><style data-mw-deduplicate="TemplateStyles:r1236075235">

/* start https://en.wikipedia.org/ */

.mw-parser-output .navbox{box-sizing:border-box;border:1px solid #a2a9b1;width:100%;clear:both;font-size:88%;text-align:center;padding:1px;margin:1em auto 0}.mw-parser-output .navbox .navbox{margin-top:0}.mw-parser-output .navbox+.navbox,.mw-parser-output .navbox+.navbox-styles+.navbox{margin-top:-1px}.mw-parser-output .navbox-inner,.mw-parser-output .navbox-subgroup{width:100%}.mw-parser-output .navbox-group,.mw-parser-output .navbox-title,.mw-parser-output .navbox-abovebelow{padding:0.25em 1em;line-height:1.5em;text-align:center}.mw-parser-output .navbox-group{white-space:nowrap;text-align:right}.mw-parser-output .navbox,.mw-parser-output .navbox-subgroup{background-color:#fdfdfd}.mw-parser-output .navbox-list{line-height:1.5em;border-color:#fdfdfd}.mw-parser-output .navbox-list-with-group{text-align:left;border-left-width:2px;border-left-style:solid}.mw-parser-output tr+tr>.navbox-abovebelow,.mw-parser-output tr+tr>.navbox-group,.mw-parser-output tr+tr>.navbox-image,.mw-parser-output tr+tr>.navbox-list{border-top:2px solid #fdfdfd}.mw-parser-output .navbox-title{background-color:#ccf}.mw-parser-output .navbox-abovebelow,.mw-parser-output .navbox-group,.mw-parser-output .navbox-subgroup .navbox-title{background-color:#ddf}.mw-parser-output .navbox-subgroup .navbox-group,.mw-parser-output .navbox-subgroup .navbox-abovebelow{background-color:#e6e6ff}.mw-parser-output .navbox-even{background-color:#f7f7f7}.mw-parser-output .navbox-odd{background-color:transparent}.mw-parser-output .navbox .hlist td dl,.mw-parser-output .navbox .hlist td ol,.mw-parser-output .navbox .hlist td ul,.mw-parser-output .navbox td.hlist dl,.mw-parser-output .navbox td.hlist ol,.mw-parser-output .navbox td.hlist ul{padding:0.125em 0}.mw-parser-output .navbox .navbar{display:block;font-size:100%}.mw-parser-output .navbox-title .navbar{float:left;text-align:left;margin-right:0.5em}body.skin--responsive .mw-parser-output .navbox-image img{max-width:none!important}@media print{body.ns-0 .mw-parser-output .navbox{display:none!important}}

/* end https://en.wikipedia.org/ */

</style></div><div role="navigation" class="navbox" aria-labelledby="Windows_Mobile137" style="padding:3px"><table class="nowraplinks mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><style data-mw-deduplicate="TemplateStyles:r1239400231">

/* start https://en.wikipedia.org/ */

.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar-collapse{float:left;text-align:left}.mw-parser-output .navbar-boxtext{word-spacing:0}.mw-parser-output .navbar ul{display:inline-block;white-space:nowrap;line-height:inherit}.mw-parser-output .navbar-brackets::before{margin-right:-0.125em;content:"[ "}.mw-parser-output .navbar-brackets::after{margin-left:-0.125em;content:" ]"}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbar a>span,.mw-parser-output .navbar a>abbr{text-decoration:inherit}.mw-parser-output .navbar-mini abbr{font-variant:small-caps;border-bottom:none;text-decoration:none;cursor:inherit}.mw-parser-output .navbar-ct-full{font-size:114%;margin:0 7em}.mw-parser-output .navbar-ct-mini{font-size:114%;margin:0 4em}html.skin-theme-clientpref-night .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}@media(prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}}@media print{.mw-parser-output .navbar{display:none!important}}

/* end https://en.wikipedia.org/ */

</style><div id="Windows_Mobile137" style="font-size:114%;margin:0 4em"><a href="Windows_Mobile" title="Windows Mobile">Windows Mobile</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Versions</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Pocket_PC_2000" title="Pocket PC 2000">Pocket PC 2000</a></li>

<li><a href="Pocket_PC_2002" title="Pocket PC 2002">Pocket PC 2002</a></li>

<li><a href="Windows_Mobile_2003" title="Windows Mobile 2003">Mobile 2003</a></li>

<li><a href="Windows_Mobile_5.0" title="Windows Mobile 5.0">Mobile 5.0</a></li>

<li><a href="Windows_Mobile_6.0" title="Windows Mobile 6.0">Mobile 6.0</a></li>

<li><a href="Windows_Mobile_6.1" title="Windows Mobile 6.1">Mobile 6.1</a></li>

<li><a href="Windows_Mobile_6.5" title="Windows Mobile 6.5">Mobile 6.5</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Device software</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Bing_Mobile" title="Bing Mobile">Bing Mobile</a>

<li><a href="Internet_Explorer_Mobile" title="Internet Explorer Mobile">Internet Explorer Mobile</a></li>

<li><a href="Windows_Media_Player#Windows_Mobile" title="Windows Media Player">Media Player Mobile</a></li>

<li><a href="MSN_Mobile" class="mw-redirect" title="MSN Mobile">MSN Mobile</a></li>

<li><a href="Microsoft_Office_Mobile" class="mw-redirect" title="Microsoft Office Mobile">Office Mobile</a></li>

<li><a href="Remote_Desktop_Services" title="Remote Desktop Services">Remote Desktop</a></li>

<li><a href="Microsoft_Voice_Command" title="Microsoft Voice Command">Voice Command</a></li>

<li><a href="Windows_Live#Mobile_services" title="Windows Live">Windows Live for Mobile</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Desktop synchronization</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="ActiveSync" title="ActiveSync">ActiveSync</a></li>

<li><a href="Handheld_PC_Explorer" title="Handheld PC Explorer">H/PC Explorer</a></li>

<li><a href="Windows_Media_Center" title="Windows Media Center">Media Center</a></li>

<li><a href="Windows_Media_Player" title="Windows Media Player">Media Player</a></li>

<li><a href="Windows_Mobile_Device_Center" title="Windows Mobile Device Center">Mobile Device Center</a></li>

<li><a href="Microsoft_Outlook" title="Microsoft Outlook">Outlook</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Microsoft_mobile_services" title="Microsoft mobile services">Services</a></th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Outlook.com#Calendar" title="Outlook.com">Calendar</a></li>

<li><a href="Outlook.com#People" title="Outlook.com">Contacts</a></li>

<li><a href="My_Phone" title="My Phone">My Phone</a></li>

<li><a href="Windows_Error_Reporting" title="Windows Error Reporting">Windows Error Reporting</a></li>

<li><a href="Windows_Marketplace_for_Mobile" title="Windows Marketplace for Mobile">Windows Marketplace for Mobile</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Server utilization</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Direct_Push" title="Direct Push">Direct Push</a></li>

<li><a href="Microsoft_Exchange_Server" title="Microsoft Exchange Server">Exchange Server</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Development</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href=".NET_Compact_Framework" title=".NET Compact Framework">.NET Compact Framework</a></li>

<li><a href="Microsoft_Device_Emulator" title="Microsoft Device Emulator">Device Emulator</a></li>

<li><a href="Microsoft_Silverlight" title="Microsoft Silverlight">Silverlight</a></li>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Models</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">HTC</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="HTC_Advantage_X7500" class="mw-redirect" title="HTC Advantage X7500">Athena</a></li>

<li><a href="HTC_Phoebus" title="HTC Phoebus">Shadow</a></li>

<li><a href="HTC_Startrek" title="HTC Startrek">Smartflip</a></li>

<li><a href="HTC_Touch" title="HTC Touch">Touch</a>

<li><a href="HTC_Touch_Cruise" title="HTC Touch Cruise">Cruise</a></li>

<li><a href="HTC_Touch_Diamond" title="HTC Touch Diamond">Diamond</a>

<li><a href="HTC_S730" title="HTC S730">Wings</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Samsung</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Samsung_SGH-i607" class="mw-redirect" title="Samsung SGH-i607">BlackJack</a>

<li><a href="Samsung_SGH-i900" class="mw-redirect" title="Samsung SGH-i900">Omnia</a>

<li><a href="Samsung_SGH-i627" class="mw-redirect" title="Samsung SGH-i627">Propel Pro</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Other</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<li><a href="LG_Incite" title="LG Incite">Incite</a></li>

<li><a href="Garmin_N%C3%BCvifone" class="mw-redirect" title="Garmin Nüvifone">nüvifone M10</a></li>

<li><a href="Garmin_N%C3%BCvifone" class="mw-redirect" title="Garmin Nüvifone">nüvifone M20</a></li>

<li><a href="Sony_Ericsson_Xperia_X1" title="Sony Ericsson Xperia X1">Xperia X1</a></li>

<li><a href="Sony_Ericsson_Xperia_X2" title="Sony Ericsson Xperia X2">Xperia X2</a></li>

</div></td></tr></tbody></table><div></div></td></tr></tbody></table></div>

<div class="navbox-styles"></div><div role="navigation" class="navbox" aria-labelledby="Microsoft_development_tools271" style="padding:3px"><table class="nowraplinks mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><div id="Microsoft_development_tools271" style="font-size:114%;margin:0 4em">Microsoft development tools</div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Development<br>environments</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Microsoft_Visual_Studio" class="mw-redirect" title="Microsoft Visual Studio">Visual Studio</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<li><a href="Microsoft_Visual_Studio_Express" title="Microsoft Visual Studio Express">Express</a></li>

<li><a href="VSTS_Profiler" title="VSTS Profiler">Team System Profiler</a></li>

<li><a href="Visual_Studio_Tools_for_Applications" title="Visual Studio Tools for Applications">Tools for Applications</a></li>

<li><a href="Visual_Studio_Tools_for_Office" title="Visual Studio Tools for Office">Tools for Office</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Others</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Microsoft_Blend" title="Microsoft Blend">Blend</a></li>

<li><a href="Microsoft_Expression_Web" title="Microsoft Expression Web">Expression Web</a></li>

<li><a href="FxCop" title="FxCop">FxCop</a></li>

<li><a href="GW-BASIC" title="GW-BASIC">GW-BASIC</a></li>

<li><a href="Microsoft_MACRO-80" title="Microsoft MACRO-80">MACRO-80</a></li>

<li><a href="Microsoft_Macro_Assembler" title="Microsoft Macro Assembler">Macro Assembler</a></li>

<li><a href="MSBuild" title="MSBuild">MSBuild</a></li>

<li><a href="Microsoft_Pascal" title="Microsoft Pascal">Pascal</a></li>

<li><a href="QuickBASIC" title="QuickBASIC">QuickBASIC</a>

<ul><li><a href="QBasic" title="QBasic">QBasic</a></li></ul></li>

<li><a href="QuickC" title="QuickC">QuickC</a></li>

<li><a href="Microsoft_Robotics_Developer_Studio" title="Microsoft Robotics Developer Studio">Robotics Developer Studio</a></li>

<li><a href="Roslyn_(compiler)" title="Roslyn (compiler)">Roslyn</a></li>

<li><a href="Microsoft_SharePoint_Designer" title="Microsoft SharePoint Designer">SharePoint Designer</a>

<ul><li><a href="Microsoft_FrontPage" title="Microsoft FrontPage">FrontPage</a></li></ul></li>

<li><a href="Microsoft_Small_Basic" title="Microsoft Small Basic">Small Basic</a></li>

<li><a href="Microsoft_WebMatrix" title="Microsoft WebMatrix">WebMatrix</a></li>

<li><a href="Windows_App_SDK" title="Windows App SDK">Windows App SDK</a></li>

<li><a href="Windows_App_Studio" title="Windows App Studio">Windows App Studio</a></li>

<li><a href="Microsoft_Windows_SDK" title="Microsoft Windows SDK">Windows SDK</a>

<ul><li><a href="CLR_Profiler" title="CLR Profiler">CLR Profiler</a></li>

<li><a href="ILAsm" title="ILAsm">ILAsm</a></li>

<li><a href="Native_Image_Generator" title="Native Image Generator">Native Image Generator</a></li>

<li><a href="WinDiff" title="WinDiff">WinDiff</a></li>

<li><a href="XAMLPad" class="mw-redirect" title="XAMLPad">XAMLPad</a></li></ul></li></ul>

</div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Languages</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Microsoft_Dynamics_AX" class="mw-redirect" title="Microsoft Dynamics AX">Dynamics AX</a></li>

<li><a href="Microsoft_BASIC" title="Microsoft BASIC">BASIC</a></li>

<li>Visual Basic

<ul><li><a href="Visual_Basic_(classic)" title="Visual Basic (classic)">legacy</a></li>

<li><a href="VBScript" title="VBScript">VBScript</a></li></ul></li>

<li><a href="Bosque_(programming_language)" title="Bosque (programming language)">Bosque</a></li>

<li><a href="Microsoft_Visual_C%2B%2B" title="Microsoft Visual C++">Visual C++</a>

<li><a href="Managed_Extensions_for_C%2B%2B" title="Managed Extensions for C++">Managed C++</a></li>

<li><a href="C%2B%2B/WinRT" title="C++/WinRT">C++/WinRT</a></li></ul></li>

<li><a href="Dafny" title="Dafny">Dafny</a></li>

<li><a href="Dexterity_(programming_language)" title="Dexterity (programming language)">Dexterity</a></li>

<li><a href="Visual_FoxPro" title="Visual FoxPro">Visual FoxPro</a></li>

<li><a href="JavaScript" title="JavaScript">JavaScript</a>

<ul><li><a href="TypeScript" title="TypeScript">TypeScript</a></li>

<li><a href="JScript" title="JScript">JScript</a></li></ul></li>

<li><a href="IronPython" title="IronPython">IronPython</a></li>

<li><a href="IronRuby" title="IronRuby">IronRuby</a></li>

<li><a href="Microsoft_Power_Fx" title="Microsoft Power Fx">Power Fx</a></li>

<li><a href="PowerShell" title="PowerShell">PowerShell</a></li>

<li><a href="Project_Verona" title="Project Verona">Project Verona</a></li>

<li><a href="Microsoft_Small_Basic" title="Microsoft Small Basic">Small Basic</a></li>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">APIs and<br>frameworks</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%;font-weight:normal;">Native</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Windows_API" title="Windows API">Windows API</a></li>

<li><a href="Microsoft_Silverlight" title="Microsoft Silverlight">Silverlight</a></li>

<li><a href="DirectX" title="DirectX">DirectX</a>

<ul><li><a href="Managed_DirectX" title="Managed DirectX">Managed DirectX</a></li></ul></li>

<li><a href="Xbox_Development_Kit" title="Xbox Development Kit">Xbox Development Kit</a></li>

<li><a href="Windows_Installer" title="Windows Installer">Windows Installer</a></li>

<li><a href="WinUI" class="mw-redirect" title="WinUI">WinUI</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;font-weight:normal;"><a href=".NET" title=".NET">.NET</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<li><a href="ASP.NET_Dynamic_Data" title="ASP.NET Dynamic Data">Dynamic Data</a></li>

<li><a href="ASP.NET_Razor" title="ASP.NET Razor">Razor</a></li>

<li><a href="ASP.NET_Web_Forms" title="ASP.NET Web Forms">Web Forms</a></li></ul></li>

<ul><li><a href="Entity_Framework" title="Entity Framework">Entity Framework</a></li></ul></li>

<li><a href="Windows_CardSpace" title="Windows CardSpace">CardSpace</a></li>

<li><a href="Windows_Communication_Foundation" title="Windows Communication Foundation">Communication Foundation</a></li>

<li><a href="Windows_Identity_Foundation" title="Windows Identity Foundation">Identity Foundation</a></li>

<li><a href="Windows_Presentation_Foundation" title="Windows Presentation Foundation">Presentation Foundation</a></li>

<li><a href="Windows_Workflow_Foundation" title="Windows Workflow Foundation">Workflow Foundation</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;font-weight:normal;"><a href="Device_driver" title="Device driver">Device drivers</a></th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<li><a href="Windows_Hardware_Lab_Kit" title="Windows Hardware Lab Kit">Windows HLK</a></li>

</div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Database</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%;font-weight:normal;"><a href="Microsoft_SQL_Server" title="Microsoft SQL Server">SQL Server</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="SQL_Server_Express" title="SQL Server Express">Express</a></li>

<li><a href="SQL_Server_Management_Studio" title="SQL Server Management Studio">Management Studio</a></li>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;font-weight:normal;">SQL services</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Microsoft_Analysis_Services" title="Microsoft Analysis Services">Analysis</a></li>

<li><a href="SQL_Server_Reporting_Services" title="SQL Server Reporting Services">Reporting</a></li>

<li><a href="SQL_Server_Integration_Services" title="SQL Server Integration Services">Integration</a></li>

<li><a href="SQL_Server_Notification_Services" title="SQL Server Notification Services">Notification</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;font-weight:normal;">Other</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Visual_FoxPro" title="Visual FoxPro">Visual FoxPro</a></li>

<li><a href="Microsoft_Access" title="Microsoft Access">Microsoft Access</a></li>

<li><a href="Access_Database_Engine" title="Access Database Engine">Access Database Engine</a></li>

<li><a href="Extensible_Storage_Engine" title="Extensible Storage Engine">Extensible Storage Engine</a></li></ul>

</div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Source control</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Microsoft_Visual_SourceSafe" title="Microsoft Visual SourceSafe">Visual SourceSafe</a></li>

<li><a href="Azure_DevOps_Server#TFVC" title="Azure DevOps Server">Team Foundation Version Control</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Testing and<br>debugging</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="CodeView" title="CodeView">CodeView</a></li>

<li><a href="OneFuzz" title="OneFuzz">OneFuzz</a></li>

<li><a href="Playwright_(software)" title="Playwright (software)">Playwright</a></li>

<li><a href="Microsoft_Script_Debugger" title="Microsoft Script Debugger">Script Debugger</a></li>

<li><a href="WinDbg" title="WinDbg">WinDbg</a></li>

<li><a href="XUnit.net" title="XUnit.net">xUnit.net</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Delivery</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Active_Setup" title="Active Setup">Active Setup</a></li>

<li><a href="ClickOnce" title="ClickOnce">ClickOnce</a></li>

<li><a href="NuGet" title="NuGet">NuGet</a></li>

<li><a href="Vcpkg" title="Vcpkg">vcpkg</a></li>

<li><a href="Web_Platform_Installer" title="Web Platform Installer">Web Platform Installer</a></li>

<li><a href="Windows_Installer" title="Windows Installer">Windows Installer</a>

<li><a href="Windows_Package_Manager" title="Windows Package Manager">Windows Package Manager</a></li>

<li><a href="Microsoft_Store" title="Microsoft Store">Microsoft Store</a></li></ul>

</div></td></tr><tr><td class="navbox-abovebelow" colspan="2"><div><span class="noviewer" typeof="mw:File"><span title="Category"></span></span> Category</div></td></tr></tbody></table></div></div><div><div class="zim-footer">

This article is issued from <a class="external text" title="Last edited on 2025-02-17" href="https://en.wikipedia.org/wiki/?title=SQL_Server_Compact&oldid=1276198290">Wikipedia</a>. The text is available under <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-Share Alike 4.0</a> unless otherwise noted. Additional terms may apply for the media files.

</div>

</div></div>

</div>

</main>

</div>

</body></html>